Dataset contains 8,760 rows and 36 columns (after dropping attributes)

Key column categories:
- Station info: STATION, DATE, LATITUDE, LONGITUDE, ELEVATION, NAME
- Weather variables: Cloud, DewPoint, Pressure, Temperature, Wind
Pittsburgh Hourly Weather Observations (1981–2010)
Cloud (% Clear) DewPoint (°F) Pressure (hPa) Temperature (°F) Wind (MPH)
count 8760.0 8760.0 8760.0 8760.0 8760.0
mean 13.12 40.57 1017.74 51.57 8.09
std 8.77 14.91 1.66 16.39 2.29
min 0.7 17.6 1014.1 23.8 3.4
25% 6.3 25.9 1016.3 36.1 6.3
50% 10.8 39.0 1018.0 51.75 8.3
75% 18.3 56.4 1019.1 65.5 9.7
max 41.4 63.4 1021.5 81.2 13.3


Cloud (Scattered %) Temperature (°F) Wind (MPH)
Month
1 5.93 28.71 9.63
2 6.46 31.48 9.41
3 7.38 39.69 9.56
4 8.54 51.33 9.28
5 11.00 60.52 7.92
6 15.00 69.10 7.05
7 16.65 72.83 6.50
8 15.33 71.31 6.16
9 11.95 64.14 6.58
10 9.84 52.78 7.36
11 7.89 42.89 8.58
12 5.94 32.80 9.15
Findings:
- June-August: temperature rises and wind decreases causing more scattered clouds in the sky.
- September-December: temperature falls and wind picks up, while cloud cover decreases.
- This proves the higher the temperature and slower the wind, the more clouds there are and vice versa.


Season Spring Summer Fall Winter
Pressure_Range_hPa
1014-1015 240 120 0 0
1015-1016 811 533 0 0
1016-1017 617 750 0 18
1017-1018 384 572 141 113
1018-1019 156 206 868 665
1019-1020 0 27 939 997
1020+ 0 0 236 367

  • How do all three relate (Wind, Temperature, Clouds)?
  • How does Pressure and DewPoint affect the other 3?
  • Are there any interesting seasonal patterns?